<%@ page language="java" import="java.util.*,java.text.*" pageEncoding="utf-8"%>
<%@page import="issuedfileaction.DBConnection;"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>       
    <title>登陆未识别文件名</title>    
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>  
  <body> 
  <%
    String begintime="";
    String endtime="";
    SimpleDateFormat sdft=new SimpleDateFormat("yyyy-MM-dd");
    String Datetime=sdft.format(new Date());
     try{
         begintime=new String(request.getParameter("begintime").getBytes("ISO-8859-1"),"gbk");
     }catch(Exception e){
         begintime="";
     }
     try{
         endtime=new String(request.getParameter("endtime").getBytes("ISO-8859-1"),"gbk");
     }catch(Exception e){
         endtime="";
     } 
     String StrSQL="select dn_sfilename,dn_filedir,dn_mfilename,dn_date,dn_id,'a' from dtunknowfile where 1=1 ";   
     StrSQL=StrSQL+" and (to_date(to_char(dn_date,'YYYY-MM-DD'),'YYYY-MM-DD')>=to_date('"+Datetime+"','YYYY-MM-DD') "; 
     StrSQL=StrSQL+" and  to_date(to_char(dn_date,'YYYY-MM-DD'),'YYYY-MM-DD')<=to_date('"+Datetime+"','YYYY-MM-DD')) ";
     List<Object> UnKnowFileListRows=new ArrayList<Object>();
     DBConnection db=new DBConnection();     
     UnKnowFileListRows=db.SQLUnKnowFileListExec(StrSQL); 
	 HttpSession httpSession = request.getSession();         
     httpSession.setAttribute("UnKnowFileListRows", UnKnowFileListRows);	
     httpSession.setAttribute("UnKnowFileBeginTime",begintime);
     httpSession.setAttribute("UnKnowFileEndTime",endtime);  
     httpSession.setAttribute("UnKnowFileStrSQL",StrSQL);          		    	  
	 response.sendRedirect("ViewUnKnowFile.jsp");                        
  %>
  </body>
</html>
